[dbo].[asi_NextSequenceForBatchDate]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_NextSequenceForBatchDate

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@prefix	nvarchar(20)	40
@systemEntityKey	uniqueidentifier	16
@increment	int	4
@startValue	int	4

SQL Script

CREATE PROCEDURE [dbo].[asi_NextSequenceForBatchDate]

@prefix nvarchar(20),
@systemEntityKey uniqueidentifier = '00000000-0000-0000-0000-000000000000',
@increment int = 1,
@startValue int = 0

AS
declare @statement nvarchar(100)
SELECT max(BatchNumber) from vBoBatch where BatchNumber like (@prefix + '%') and
SystemEntityKey = @systemEntityKey

GO

Uses